
<%@page import="java.util.ArrayList"%>
<%@page import="classes.Reports"%>
<form action="veiwstockshare.html">
    <table>
            <tr><td><font>Stock</font></td><td> <select name="stock">
            <% 
            Reports.getConnection("SELECT * FROM brchung.stock;");
            ArrayList<String[]> rs=Reports.getResults(1);
            for(int i=0;i<rs.size();i++)
            {
                out.println("<option value=\""+rs.get(i)[0] +"\">"+rs.get(i)[0] +"</option>");
            }
            %>
            </select></td></tr>
        <tr><td><font>Period</font></td><td> <select name="period">
                    <option value="week">Past a week</option>
                    <option value="month">Past a month</option>
                    <option value="six">Past six month</option>
                    <option value="year">Past a year</option>
                </select></td></tr>
    </table>
    <input type="submit" Value="Submit"/>
</form>